Returns the number of characters specified in the number-of-characters argument from the text specified in the text argument. The returned text string starts from the leftmost character in the text argument, and extends for the given number of characters.
Format: LEFT (text, number-of-characters)
Arguments:
ΓÇó text: A text expression.
ΓÇó number-of-characters: A number, a cell reference, or a field name that contains a number.
Example:
LEFT ("Pauline Mitchell", 4) returns Paul.
Shows that the first four characters in the text are Paul.